Lista referencji diagramu

Name

Code

Parent Table

Child Table

Foreign Key Columns

Parent Role

Child Role

R_1262

R_1262

ReferralSource

LBPServiceReferralSource

ReferralSourceID

 

 

R_1263

R_1263

InformationAttribute

LBPServiceInformationAttr

InformationAttributeID

 

 

R_1264

R_1264

InformationAttribute

InformationAttributeText

InformationAttributeID

 

 

R_1269

R_1269

PriceListKind

PriceListKindText

PackageKind

 

 

R_1271

R_1271

PriceListKind

PriceList

PackageKind

 

 

R_1273

R_1273

TimeSlotType

PriceList

TimeslotTypeID

 

 

R_1274

R_1274

TimeSlotType

TimeSlotTypeConflict

TimeslotTypeID

 

 

R_1275

R_1275

TimeSlotType

TimeSlotTypeConflict

Tim_TimeslotTypeID

 

 

R_1280

R_1280

ActivationWay

ActivationWayText

ActivationWayID

 

 

R_1281

R_1281

ActivationWay

Contract

ActivationWayID

 

 

R_1284

R_1284

CancelReason

CancelReasonText

CancelReasonID

 

 

R_1287

R_1287

ContractBlockType

ContractBlockTypeText

ContractBlockTypeID

 

 

R_1288

R_1288

ContractBlockType

LContractStatus

ContractBlockTypeID

 

 

R_1293

R_1293

ContractType

ContractTypeText

ContractTypeID

 

 

R_1295

R_1295

ContractType

Contract

ContractTypeID

 

 

R_1296

R_1296

InvoiceChangeRule

InvoiceChangeRuleText

InvoiceChangeRuleID

 

 

R_1298

R_1298

LimitBase

ContractLimit

LimitBaseID

 

 

R_1299

R_1299

LimitBase

LimitBaseText

LimitBaseID

 

 

R_1301

R_1301

ContractSubject

Contract

ContractSubjectID

 

 

R_1302

R_1302

ContractSubject

ContractSubjectText

ContractSubjectID

 

 

R_1304

R_1304

Contract

LContractStatus

ContractID

 

 

R_1305

R_1305

BenefitPlanType

BenefitPlanContract

BenefitPlanTypeID

 

 

R_1306

R_1306

Personnel

LContractPersonnel

PersonID

 

 

R_1307

R_1307

BenefitPlanType

BenefitPlanTypeText

BenefitPlanTypeID

 

 

R_1309

R_1309

ContractLinkType

LContractContract

ContractLinkTypeID

 

 

R_1312

R_1312

LBenefitPlanService

LBPServiceReferralSource

LBenefitPlanServID

 

 

R_1313

R_1313

PriceList

LBPServicePriceList

PriceListID

 

 

R_1314

R_1314

LBenefitPlanService

LBPServiceOrgUnitGroup

LBenefitPlanServID

 

 

R_1319

R_1319

Person

LContractPerson

PersonID

 

 

R_1320

R_1320

Contract

LContractPerson

ContractID

 

 

R_1327

R_1327

Contract

LContractPersonnel

ContractID

 

 

R_1328

R_1328

ContractLinkType

ContractLinkTypeText

ContractLinkTypeID

 

 

R_1331

R_1331

BeneficiaryStatus

BenefitPlanContract

BeneficiaryStatusID

 

 

R_1332

R_1332

SalesCenter

Contract

SalesCenterID

 

 

R_1333

R_1333

SalesCenter

SalesCenterText

SalesCenterID

 

 

R_1335

R_1335

Contract

LContractContactPerson

ContractID

 

 

R_1336

R_1336

Person

LContractContactPerson

PersonID

 

 

R_1337

R_1337

LBenefitPlanContrBeneficiary

BeneficiaryAdditionalData

LBenefitPlanContrBeneficiaryID

 

 

R_1341

R_1341

PriceList

LPriceListOrgUnitGroup

PriceListID

 

 

R_1342

R_1342

BenefitPlanContract

LBenefitPlanContractLimit

BenefitPlanContractID

 

 

R_1343

R_1343

LBenefitPlanService

LBenefitPlanServiceLimit

LBenefitPlanServID

 

 

R_1344

R_1344

Contract

ContractAnnex

ContractID

 

 

R_1346

R_1346

Contract

LContractCareTaker

ContractID

 

 

R_1347

R_1347

PriceList

LFrequencyPriceList

PriceListID

 

 

R_1348

R_1348

Frequency

LFrequencyPriceList

FrequencyID

 

 

R_1352

R_1352

OrgUnitGroup

LContractOrgUnitGroup

OrgUnitGroupID

 

 

R_1353

R_1353

Contract

LContractOrgUnitGroup

ContractID

 

 

R_1354

R_1354

Craft

Contractor

CraftID

 

 

R_1355

R_1355

Craft

CraftText

CraftID

 

 

R_1357

R_1357

OrgUnitGroup

LBPServiceOrgUnitGroup

OrgUnitGroupID

 

 


1  2  3  4